home *** CD-ROM | disk | FTP | other *** search
/ NeXTSTEP 3.3 (Developer)…68k, x86, SPARC, PA-RISC] / NeXTSTEP 3.3 Dev Intel.iso / usr / sybase / doc / types.man < prev   
Text File  |  1993-04-22  |  4KB  |  111 lines
  1.  
  2.   1                       Version 4.0 -- 5/1/89                    types
  3.   ______________________________________________________________________
  4.  
  5.   NAME:  types
  6.  
  7.   FUNCTION:
  8.        List of data typedefs and defines used by DB-Library.
  9.  
  10.   SYNTAX:
  11.        #include <sybfront.h>
  12.        #include <sybdb.h>
  13.  
  14.   COMMENTS:
  15.  
  16.        o Here is  a  list  of  SQL Server  datatypes.   dbconvert()  and
  17.          dbwillconvert()  use  these  types.   In addition, the routines
  18.  
  19.  
  20.  
  21.  
  22.  
  23.  
  24.   types                   Version 4.0 -- 5/1/89                        2
  25.   ______________________________________________________________________
  26.          dbcoltype(), dbalttype(), and dbrettype() will  return  one  of
  27.          these types.
  28.  
  29.               SYBCHAR                 /* char type */
  30.               SYBTEXT                 /* text type */
  31.               SYBBINARY               /* binary type */
  32.               SYBIMAGE                /* image type */
  33.               SYBINT1                 /* 1-byte integer */
  34.               SYBINT2                 /* 2-byte integer */
  35.               SYBINT4                 /* 4-byte integer */
  36.               SYBFLT8                 /* 8-byte float type */
  37.               SYBBIT                  /* bit type */
  38.               SYBMONEY                /* money type */
  39.               SYBDATETIME             /* datetime type */
  40.  
  41.          For more information on SQL Server datatypes, see the  Commands
  42.          Reference.
  43.  
  44.  
  45.  
  46.   3                       Version 4.0 -- 5/1/89                    types
  47.   ______________________________________________________________________
  48.  
  49.        o Here is a list of typedefs used by DB-Library functions.  These
  50.          typedefs  are  useful  for defining program variables, particu-
  51.          larly variables used with  dbbind(),  dbaltbind(),  and  dbcon-
  52.          vert().
  53.  
  54.               typedef char              DBCHAR;              /* char and text type */
  55.               typedef unsigned char     DBBINARY;            /* binary and image type */
  56.               typedef unsigned char     DBTINYINT;           /* 1-byte integer */
  57.               typedef short             DBSMALLINT;          /* 2-byte integer */
  58.               typedef unsigned short    DBUSMALLINT;         /* unsigned 2-byte integer */
  59.               typedef long              DBINT;               /* 4-byte integer */
  60.               typedef double            DBFLT8;              /* 8-byte float type */
  61.               typedef unsigned char     DBBIT;               /* bit type */
  62.               typedef int               RETCODE;             /* SUCCEED or FAIL */
  63.  
  64.  
  65.  
  66.  
  67.  
  68.   types                   Version 4.0 -- 5/1/89                        4
  69.   ______________________________________________________________________
  70.               typedef struct money                           /* money type */
  71.               {
  72.                   long                mnyhigh;
  73.                   long                mnylow;
  74.               } DBMONEY;
  75.  
  76.               typedef struct datetime                        /* datetime type */
  77.               {
  78.                   long                dtdays;                /* number of days since 1/1/1900 */
  79.                   unsigned long       dttime;                /* 300ths of a second since midnight */
  80.               } DBDATETIME;
  81.  
  82.               typedef struct dbvarychar                      /* Pascal-type string. */
  83.               {
  84.                   DBSMALLINT          len;                   /* character count */
  85.                   DBCHAR              str[DBMAXCHAR];        /* non-terminated string */
  86.               } DBVARYCHAR;
  87.  
  88.  
  89.  
  90.   5                       Version 4.0 -- 5/1/89                    types
  91.   ______________________________________________________________________
  92.  
  93.               typedef struct dbvarybin                       /* Pascal-type binary array. */
  94.               {
  95.                   DBSMALLINT          len;                   /* byte count */
  96.                   BYTE                array[DBMAXCHAR];      /* non-terminated array */
  97.               } DBVARYBIN;
  98.  
  99.               typedef DBSMALLINT DBINDICATOR;                /* used by DB-Library
  100.                                                                 for indicator variables. */
  101.  
  102.  
  103.   SEE ALSO:
  104.        dbaltbind, dbalttype,  dbbind,  dbcoltype,  dbconvert,  dbprtype,
  105.        dbrettype, dbwillconvert, options
  106.  
  107.  
  108.  
  109.  
  110.  
  111.